package com.bootdo.lvyou.dao;

import com.bootdo.lvyou.domain.LvyouFeiyi;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 非遗表
 * @author lujingqian
 * @email 965858129@qq.com
 * @date 2019-10-11 16:22:07
 */
@Mapper
public interface LvyouFeiyiDao {

	LvyouFeiyi get(Long id);
	
	List<LvyouFeiyi> list(Map<String,Object> map);
	
	int count(Map<String,Object> map);
	
	int save(LvyouFeiyi lvyouFeiyi);
	
	int update(LvyouFeiyi lvyouFeiyi);
	
	int remove(Long id);
	
	int batchRemove(Long[] ids);

	@Select("select id,name,city_id,city_name,cover_img,presentation,lat,lng,site from me_lvyou_feiyi  where is_show=1 and city_id=#{cityId}")
    List<LvyouFeiyi> getByCityId(@Param("cityId") Long cityId);
	/*@Select("select id,city_id,city_name,name,map_icon,cover_img,level,lat,lng,site,is_show,create_time from me_lvyou_feiyi where is_show=1 and city_id=#{cityId}")
    List<LvyouFeiyi> getByCityId(@Param("cityId") Long cityId);*/

	List<LvyouFeiyi> getByCityIdLatAndLng(Map<String,Object> map);
}
